Variant[].FindSorted (gb)
Function FindSorted ( Value As Variant [ , Start As Integer ] ) As Integer
Since 3.16
Returns the position of the first occurrence of
Value in the array.
If
Start is specified, then the search begins at the
Start position. By default the entire array is searched.
If
Value cannot be found, a negative value is returned. It equals
-1 - pos, where
pos is the position
Value should be inserted at to keep the array sorted.
This method only works if the array is sorted.
But it is faster than the
Find method as it uses a binary search algorithm.